package org.ushio.nchu_22201404.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.ushio.common_module.entity.CustomerService;

import java.util.List;

@Mapper
public interface CustomerServiceDao {
    @Select("SELECT * FROM customer_service")
    @Results({
            @Result(property = "customerServiceID", column = "Customer_Service_ID"),
            @Result(property = "name", column = "Name"),
            @Result(property = "password", column = "Password"),
            @Result(property = "contactNumber", column = "Contact_Number"),
            @Result(property = "rating", column = "Rating"),
            @Result(property = "salary", column = "Salary")
    })
    List<CustomerService> getCustomerServiceInfo();
}
